microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

Question : 1

Which area in an Excel window allows entering values and formulas

a) Title Bar

b) Menu Bar

c) Formula Bar

d) Standard Tool Bar

e) None of these

Question : 2

In Excel A data map is helpful

a) When you have too much data to chart

b) To show a geographic distribution of data

c) To compare data points

d) To show changes in data over time

Question : 3

You can set Page Border in Excel from

a) From Border tab in Format Cells dialog box

b) From Border tool in Formatting toolbar

c) From Line Style tool in Drawing toolbar

d) You can not set page border in Excel

e) None of these

Question : 4

What's a quick way to extend these numbers to a longer sequence, for instance 1 through 20?

a) Select both cells, and then drag the fill handle over the range you- want, for instance 18 more rows

b) Select the range you want, include both cells, point to fill on the Edit menu, and then click down.

c) Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special

d) All of above

e) None of these

Question : 5

In Excel the following is not an underline option in the format cells dialog box

a) Double

b) Single Engineering

c) Single Accounting

d) Double Accounting